-- ----------------------------
-- Records of article
-- ----------------------------
BEGIN;
INSERT INTO `article` (`id`, `article_id`, `user_id`, `title`, `author`, `author_url`, `type`, `publish_type`, `source`, `source_url`, `avatar`, `cover`, `author_accounts`, `author_accounts_public`, `remarks`, `jump_url`, `jump_type`, `sort`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `brief_content`, `category_id`, `topping`) VALUES (30, '1080269597699080192', NULL, '【笔记】Linux安装Docker', 'quan', NULL, 1, 1, NULL, NULL, NULL, 'https://file.javaquan.cn/public/article-default.svg', NULL, b'0', NULL, NULL, 1, 0, '2023-02-28 23:25:43', '2024-01-27 14:41:50', '2', '2', 0, b'0', 'Linux安装Docker', '1149087476233666560', b'0');
INSERT INTO `article` (`id`, `article_id`, `user_id`, `title`, `author`, `author_url`, `type`, `publish_type`, `source`, `source_url`, `avatar`, `cover`, `author_accounts`, `author_accounts_public`, `remarks`, `jump_url`, `jump_type`, `sort`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `brief_content`, `category_id`, `topping`) VALUES (31, '1080274561267793920', NULL, '【笔记】配置Docker网络', 'quan', NULL, 1, 1, NULL, NULL, NULL, 'https://file.javaquan.cn/public/article-default.svg', NULL, b'0', NULL, NULL, 1, 1, '2023-02-28 23:45:26', '2024-01-19 23:43:00', '2', NULL, 0, b'0', '配置Docker网络', '1149087476233666560', b'0');
INSERT INTO `article` (`id`, `article_id`, `user_id`, `title`, `author`, `author_url`, `type`, `publish_type`, `source`, `source_url`, `avatar`, `cover`, `author_accounts`, `author_accounts_public`, `remarks`, `jump_url`, `jump_type`, `sort`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `brief_content`, `category_id`, `topping`) VALUES (32, '1080960516626710528', NULL, '【笔记】Docker安装Matomo数据统计', 'quan', NULL, 1, 1, NULL, NULL, NULL, 'https://file.javaquan.cn/public/article-default.svg', NULL, b'0', NULL, NULL, 1, 3, '2023-03-02 21:11:10', '2024-01-27 23:43:53', '2', '2', 0, b'0', '个人觉得国内百度统计因为免费、方便快捷，最适合个人网站。但不足在于使用免费的产品，出现问题极难解决。所以决定使用一个替代方案：Matomo', '1149087476233666560', b'0');
INSERT INTO `article` (`id`, `article_id`, `user_id`, `title`, `author`, `author_url`, `type`, `publish_type`, `source`, `source_url`, `avatar`, `cover`, `author_accounts`, `author_accounts_public`, `remarks`, `jump_url`, `jump_type`, `sort`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `brief_content`, `category_id`, `topping`) VALUES (33, '1080974668384567296', NULL, '【笔记】Docker安装Mongodb', 'quan', NULL, 1, 1, NULL, NULL, NULL, 'https://file.javaquan.cn/public/article-default.svg', NULL, b'0', NULL, NULL, 1, 0, '2023-03-02 22:07:24', '2023-09-26 14:57:00', '2', '2', 0, b'0', 'Docker安装Mongodb；项目基于SpringBoot 2.7.6，使用Mongodb数据源。', '1149087244141854720', b'0');
INSERT INTO `article` (`id`, `article_id`, `user_id`, `title`, `author`, `author_url`, `type`, `publish_type`, `source`, `source_url`, `avatar`, `cover`, `author_accounts`, `author_accounts_public`, `remarks`, `jump_url`, `jump_type`, `sort`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `brief_content`, `category_id`, `topping`) VALUES (34, '1083462433600831488', NULL, 'sitemap.xml文件标准格式说明', 'detayun.cn', 'https://www.detayun.cn', 2, 1, 'detayun.cn', 'https://www.detayun.cn/blog/blogArticlePage/?blog_id=f1b265ba-fb7a-11ec-ac54-c0e43482dd20&_=1656926601120', 'https://www.detayun.cn/static/img/detayun_logo3.png', 'https://file.javaquan.cn/public/article-default.svg', NULL, b'0', NULL, '', 1, 10, '2023-03-09 18:52:54', '2023-09-26 14:57:00', '2', '2', 0, b'0', 'sitemap.xml文件标准格式说明', '1146940481758953472', b'0');
INSERT INTO `article` (`id`, `article_id`, `user_id`, `title`, `author`, `author_url`, `type`, `publish_type`, `source`, `source_url`, `avatar`, `cover`, `author_accounts`, `author_accounts_public`, `remarks`, `jump_url`, `jump_type`, `sort`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `brief_content`, `category_id`, `topping`) VALUES (53, '1148225827448684544', NULL, '【Mysql8.1】EXPLAIN执行计划说明', 'javaquan', NULL, 1, 1, NULL, NULL, NULL, 'https://file.javaquan.cn/public/article-default.svg', NULL, b'0', NULL, NULL, 1, 0, '2023-09-04 11:59:30', '2024-01-13 16:54:07', NULL, NULL, 0, b'0', 'EXPLAIN语句提供了有关MySQL如何执行语句的信息。EXPLAIN适用于SELECT、DELETE、INSERT、REPLACE和UPDATE语句。', '1149087244141854720', b'0');
INSERT INTO `article` (`id`, `article_id`, `user_id`, `title`, `author`, `author_url`, `type`, `publish_type`, `source`, `source_url`, `avatar`, `cover`, `author_accounts`, `author_accounts_public`, `remarks`, `jump_url`, `jump_type`, `sort`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `brief_content`, `category_id`, `topping`) VALUES (54, '1149356083521912832', NULL, '记录Ant Design Pro 菜单不显示问题', 'javaquan', NULL, 1, 1, NULL, NULL, NULL, 'https://file.javaquan.cn/public/article-default.svg', NULL, b'0', NULL, NULL, 1, 0, '2023-09-07 14:50:44', '2024-04-07 09:56:40', NULL, NULL, 0, b'0', '记录一次错误配置导致的菜单不显示问题。项目基于Ant Design Pro V5 ，在本地调试能正常加载远程菜单并显示。但打包上传到服务器，使用Nginx访问时，远程菜单无法加载！通过最终不断的尝试，最终发现是一个错误配置导致。', '1149087084468895744', b'0');
INSERT INTO `article` (`id`, `article_id`, `user_id`, `title`, `author`, `author_url`, `type`, `publish_type`, `source`, `source_url`, `avatar`, `cover`, `author_accounts`, `author_accounts_public`, `remarks`, `jump_url`, `jump_type`, `sort`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `brief_content`, `category_id`, `topping`) VALUES (55, '1173651087715074048', NULL, '【测试】测试文章', 'javaquan', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, b'0', '测试文章', NULL, NULL, 0, '2023-11-13 15:50:25', '2023-11-20 01:52:01', NULL, NULL, 2, b'1', '测试文章', '1146940481758953472', b'0');
INSERT INTO `article` (`id`, `article_id`, `user_id`, `title`, `author`, `author_url`, `type`, `publish_type`, `source`, `source_url`, `avatar`, `cover`, `author_accounts`, `author_accounts_public`, `remarks`, `jump_url`, `jump_type`, `sort`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `brief_content`, `category_id`, `topping`) VALUES (56, '1183803984528408576', NULL, '【测试】文章', 'test', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, b'0', NULL, NULL, NULL, 0, '2023-12-11 16:14:24', '2023-12-11 16:14:58', NULL, NULL, 2, b'0', 'test', '1146940481758953472', b'0');
INSERT INTO `article` (`id`, `article_id`, `user_id`, `title`, `author`, `author_url`, `type`, `publish_type`, `source`, `source_url`, `avatar`, `cover`, `author_accounts`, `author_accounts_public`, `remarks`, `jump_url`, `jump_type`, `sort`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `brief_content`, `category_id`, `topping`) VALUES (57, '1200952712498380800', NULL, '【笔记】Artalk 评论系统问题', 'JavaQuan', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, b'0', NULL, NULL, 1, 0, '2024-01-27 23:57:19', '2024-04-26 10:41:39', NULL, NULL, 0, b'1', 'Artalk 评论系统问题', '1146940481758953472', b'1');
INSERT INTO `article` (`id`, `article_id`, `user_id`, `title`, `author`, `author_url`, `type`, `publish_type`, `source`, `source_url`, `avatar`, `cover`, `author_accounts`, `author_accounts_public`, `remarks`, `jump_url`, `jump_type`, `sort`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `brief_content`, `category_id`, `topping`) VALUES (58, '1214599156782465024', NULL, '【笔记】Mac删除zip包内文件', 'javaquan', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, b'0', '笔记', NULL, 1, 0, '2024-03-05 15:43:25', '2024-03-05 15:43:46', NULL, NULL, 0, b'0', 'zip -d filename.zip \"__MACOSX*\"', '1146940481758953472', b'0');
INSERT INTO `article` (`id`, `article_id`, `user_id`, `title`, `author`, `author_url`, `type`, `publish_type`, `source`, `source_url`, `avatar`, `cover`, `author_accounts`, `author_accounts_public`, `remarks`, `jump_url`, `jump_type`, `sort`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `brief_content`, `category_id`, `topping`) VALUES (59, '1219975936586416128', NULL, '解决“Liquibase: Waiting for changelog lock”数据库死锁问题', 'bboyHan', 'https://blog.csdn.net/han0373?type=blog', 2, 1, 'csdn', 'https://blog.csdn.net/han0373/article/details/108471481', NULL, NULL, NULL, b'0', NULL, NULL, 1, 0, '2024-03-20 11:48:49', '2024-03-20 19:05:43', NULL, NULL, 0, b'0', '启动程序时报错\"Liquibase: Waiting for changelog lock...\"', '1149087244141854720', b'0');
INSERT INTO `article` (`id`, `article_id`, `user_id`, `title`, `author`, `author_url`, `type`, `publish_type`, `source`, `source_url`, `avatar`, `cover`, `author_accounts`, `author_accounts_public`, `remarks`, `jump_url`, `jump_type`, `sort`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `brief_content`, `category_id`, `topping`) VALUES (60, '1220083916224987136', NULL, '【笔记】根据属性去重且不改变集合顺序', 'JavaQuan', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, b'0', NULL, NULL, 1, 0, '2024-03-20 18:57:54', '2024-04-11 23:40:51', NULL, NULL, 0, b'0', '基于Java8根据属性去重，且不改变集合顺序的简单实现。', '1149087244141854720', b'0');
INSERT INTO `article` (`id`, `article_id`, `user_id`, `title`, `author`, `author_url`, `type`, `publish_type`, `source`, `source_url`, `avatar`, `cover`, `author_accounts`, `author_accounts_public`, `remarks`, `jump_url`, `jump_type`, `sort`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `brief_content`, `category_id`, `topping`) VALUES (61, '1237054899401916416', NULL, '【笔记】mac安装 Node 版本切换工具', 'JavaQuan', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, b'0', NULL, NULL, 1, 0, '2024-05-06 14:54:31', '2024-05-06 14:56:12', NULL, NULL, 0, b'0', '由于开发不同的前端项目所需的node版本不一致，经常需要切换node环境。因此安装nvm工具快速处理。', '1149087084468895744', b'0');
INSERT INTO `article` (`id`, `article_id`, `user_id`, `title`, `author`, `author_url`, `type`, `publish_type`, `source`, `source_url`, `avatar`, `cover`, `author_accounts`, `author_accounts_public`, `remarks`, `jump_url`, `jump_type`, `sort`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `brief_content`, `category_id`, `topping`) VALUES (62, '1238558446937309184', NULL, '基于Antd自定义图标选则组件', 'JavaQuan', NULL, 1, 1, NULL, NULL, NULL, 'https://file.javaquan.cn/public/845649a97f5537d5a101673777d0b985.jpg', NULL, b'0', NULL, NULL, 1, 0, '2024-05-10 18:29:05', '2024-06-04 18:22:02', NULL, NULL, 0, b'0', '基于Ant Design 组件自定义图标选则工具', '1149087084468895744', b'1');
COMMIT;

-- ----------------------------
-- Records of article_category
-- ----------------------------
BEGIN;
INSERT INTO `article_category` (`id`, `category_id`, `name`, `type`, `create_time`, `update_time`, `create_user`, `update_user`, `del_flag`, `color`, `sort`) VALUES (1, '1001', '后端', 1, NULL, '2023-08-31 14:50:02', NULL, NULL, b'1', '#55acee', 2);
INSERT INTO `article_category` (`id`, `category_id`, `name`, `type`, `create_time`, `update_time`, `create_user`, `update_user`, `del_flag`, `color`, `sort`) VALUES (2, '1002', '前端', 1, NULL, '2023-08-31 14:49:50', NULL, NULL, b'1', 'blue', 3);
INSERT INTO `article_category` (`id`, `category_id`, `name`, `type`, `create_time`, `update_time`, `create_user`, `update_user`, `del_flag`, `color`, `sort`) VALUES (3, '1003', '笔记', 1, NULL, '2023-08-31 14:50:04', NULL, NULL, b'1', 'yellow', 1);
INSERT INTO `article_category` (`id`, `category_id`, `name`, `type`, `create_time`, `update_time`, `create_user`, `update_user`, `del_flag`, `color`, `sort`) VALUES (4, NULL, 'Vue', 0, '2023-08-30 23:57:06', '2023-08-30 16:08:15', NULL, NULL, b'1', 'red', 0);
INSERT INTO `article_category` (`id`, `category_id`, `name`, `type`, `create_time`, `update_time`, `create_user`, `update_user`, `del_flag`, `color`, `sort`) VALUES (5, NULL, 'Java', 0, '2023-08-30 23:57:25', '2023-08-30 16:08:23', NULL, NULL, b'1', 'blue', 0);
INSERT INTO `article_category` (`id`, `category_id`, `name`, `type`, `create_time`, `update_time`, `create_user`, `update_user`, `del_flag`, `color`, `sort`) VALUES (6, NULL, 'css', 1, '2023-08-30 23:57:56', '2023-08-30 16:08:23', NULL, NULL, b'1', NULL, 0);
INSERT INTO `article_category` (`id`, `category_id`, `name`, `type`, `create_time`, `update_time`, `create_user`, `update_user`, `del_flag`, `color`, `sort`) VALUES (7, NULL, 'test', 1, '2023-08-31 00:00:06', '2023-08-30 16:08:19', NULL, NULL, b'1', 'yellow', 0);
INSERT INTO `article_category` (`id`, `category_id`, `name`, `type`, `create_time`, `update_time`, `create_user`, `update_user`, `del_flag`, `color`, `sort`) VALUES (8, '1146759209518497792', 'Vue', 1, '2023-08-31 10:51:41', '2023-08-31 14:49:27', NULL, NULL, b'1', 'blue', 4);
INSERT INTO `article_category` (`id`, `category_id`, `name`, `type`, `create_time`, `update_time`, `create_user`, `update_user`, `del_flag`, `color`, `sort`) VALUES (9, '1146940166678642688', '笔记', 1, '2023-08-31 22:50:45', '2023-09-07 05:10:13', NULL, NULL, b'1', 'yellow', -1);
INSERT INTO `article_category` (`id`, `category_id`, `name`, `type`, `create_time`, `update_time`, `create_user`, `update_user`, `del_flag`, `color`, `sort`) VALUES (10, '1146940481758953472', '其它', 1, '2023-08-31 22:52:00', '2023-09-04 16:46:03', NULL, NULL, b'0', 'orange', 0);
INSERT INTO `article_category` (`id`, `category_id`, `name`, `type`, `create_time`, `update_time`, `create_user`, `update_user`, `del_flag`, `color`, `sort`) VALUES (11, '1146945973956771840', '前端', 1, '2023-08-31 23:13:49', '2023-09-06 12:50:46', NULL, NULL, b'1', NULL, 0);
INSERT INTO `article_category` (`id`, `category_id`, `name`, `type`, `create_time`, `update_time`, `create_user`, `update_user`, `del_flag`, `color`, `sort`) VALUES (12, '1146946001685315584', '后端', 1, '2023-08-31 23:13:56', '2023-09-06 12:50:46', NULL, NULL, b'1', NULL, 0);
INSERT INTO `article_category` (`id`, `category_id`, `name`, `type`, `create_time`, `update_time`, `create_user`, `update_user`, `del_flag`, `color`, `sort`) VALUES (13, '1146946043749990400', '运维', 1, '2023-08-31 23:14:06', '2023-09-06 12:50:46', NULL, NULL, b'1', NULL, 0);
INSERT INTO `article_category` (`id`, `category_id`, `name`, `type`, `create_time`, `update_time`, `create_user`, `update_user`, `del_flag`, `color`, `sort`) VALUES (14, '1146946081322565632', 'Java', 1, '2023-08-31 23:14:15', '2023-09-06 12:50:46', NULL, NULL, b'1', NULL, 0);
INSERT INTO `article_category` (`id`, `category_id`, `name`, `type`, `create_time`, `update_time`, `create_user`, `update_user`, `del_flag`, `color`, `sort`) VALUES (15, '1146946117762678784', 'Spring', 1, '2023-08-31 23:14:24', '2023-09-06 12:50:46', NULL, NULL, b'1', NULL, 0);
INSERT INTO `article_category` (`id`, `category_id`, `name`, `type`, `create_time`, `update_time`, `create_user`, `update_user`, `del_flag`, `color`, `sort`) VALUES (16, '1146946417114349568', 'Docker', 1, '2023-08-31 23:15:35', '2023-09-06 12:59:52', NULL, NULL, b'1', 'blue', -1);
INSERT INTO `article_category` (`id`, `category_id`, `name`, `type`, `create_time`, `update_time`, `create_user`, `update_user`, `del_flag`, `color`, `sort`) VALUES (17, '1148226434196701184', 'MySQL', 1, '2023-09-04 12:01:55', '2023-09-06 12:59:49', NULL, NULL, b'1', '#396187', -1);
INSERT INTO `article_category` (`id`, `category_id`, `name`, `type`, `create_time`, `update_time`, `create_user`, `update_user`, `del_flag`, `color`, `sort`) VALUES (18, '1149087084468895744', '前端', 1, '2023-09-06 21:01:50', '2023-09-06 22:40:02', NULL, NULL, b'0', '#9bbc39', -2);
INSERT INTO `article_category` (`id`, `category_id`, `name`, `type`, `create_time`, `update_time`, `create_user`, `update_user`, `del_flag`, `color`, `sort`) VALUES (19, '1149087244141854720', '服务端', 1, '2023-09-06 21:02:28', '2023-09-06 22:40:09', NULL, NULL, b'0', '#6cb52d', -3);
INSERT INTO `article_category` (`id`, `category_id`, `name`, `type`, `create_time`, `update_time`, `create_user`, `update_user`, `del_flag`, `color`, `sort`) VALUES (20, '1149087476233666560', '运维', 1, '2023-09-06 21:03:23', NULL, NULL, NULL, b'0', '#0F7ADF', 0);
COMMIT;

-- ----------------------------
-- Records of article_category_config
-- ----------------------------
BEGIN;
INSERT INTO `article_category_config` (`id`, `article_id`, `category_id`, `del_flag`) VALUES (1, '1080269597699080192', '1001', b'1');
INSERT INTO `article_category_config` (`id`, `article_id`, `category_id`, `del_flag`) VALUES (2, '1080274561267793920', '1002', b'1');
INSERT INTO `article_category_config` (`id`, `article_id`, `category_id`, `del_flag`) VALUES (3, '1080960516626710528', '1003', b'1');
INSERT INTO `article_category_config` (`id`, `article_id`, `category_id`, `del_flag`) VALUES (4, '1080974668384567296', '1001', b'1');
INSERT INTO `article_category_config` (`id`, `article_id`, `category_id`, `del_flag`) VALUES (5, '1080974668384567296', '1002', b'1');
INSERT INTO `article_category_config` (`id`, `article_id`, `category_id`, `del_flag`) VALUES (6, '1080974668384567296', '1003', b'1');
INSERT INTO `article_category_config` (`id`, `article_id`, `category_id`, `del_flag`) VALUES (7, '1080269597699080192', '1146940166678642688', b'1');
INSERT INTO `article_category_config` (`id`, `article_id`, `category_id`, `del_flag`) VALUES (8, '1080274561267793920', '1146940166678642688', b'1');
INSERT INTO `article_category_config` (`id`, `article_id`, `category_id`, `del_flag`) VALUES (9, '1080974668384567296', '1146940166678642688', b'1');
INSERT INTO `article_category_config` (`id`, `article_id`, `category_id`, `del_flag`) VALUES (10, '1083462433600831488', '1146940166678642688', b'1');
INSERT INTO `article_category_config` (`id`, `article_id`, `category_id`, `del_flag`) VALUES (11, '1083462433600831488', '1146940481758953472', b'0');
INSERT INTO `article_category_config` (`id`, `article_id`, `category_id`, `del_flag`) VALUES (12, '1080974668384567296', '1146946417114349568', b'1');
INSERT INTO `article_category_config` (`id`, `article_id`, `category_id`, `del_flag`) VALUES (13, '1080269597699080192', '1146946417114349568', b'1');
INSERT INTO `article_category_config` (`id`, `article_id`, `category_id`, `del_flag`) VALUES (14, '1080274561267793920', '1146946417114349568', b'1');
INSERT INTO `article_category_config` (`id`, `article_id`, `category_id`, `del_flag`) VALUES (15, '1080960516626710528', '1146940166678642688', b'1');
INSERT INTO `article_category_config` (`id`, `article_id`, `category_id`, `del_flag`) VALUES (16, '1080960516626710528', '1146946417114349568', b'1');
INSERT INTO `article_category_config` (`id`, `article_id`, `category_id`, `del_flag`) VALUES (17, '1148225827448684544', '1146940166678642688', b'1');
INSERT INTO `article_category_config` (`id`, `article_id`, `category_id`, `del_flag`) VALUES (18, '1148225827448684544', '1148226434196701184', b'1');
COMMIT;

-- ----------------------------
-- Records of article_tag
-- ----------------------------
BEGIN;
INSERT INTO `article_tag` (`id`, `tag_id`, `name`, `color`, `icon`, `type`, `update_time`, `del_flag`, `sort`) VALUES (1, '1149084409815760896', 'MySql', '#396187', NULL, 1, '2023-09-06 20:55:39', b'0', 0);
INSERT INTO `article_tag` (`id`, `tag_id`, `name`, `color`, `icon`, `type`, `update_time`, `del_flag`, `sort`) VALUES (2, '1149085902136541184', 'Docker', '#003f8c', NULL, 1, '2023-09-06 20:57:08', b'0', 0);
INSERT INTO `article_tag` (`id`, `tag_id`, `name`, `color`, `icon`, `type`, `update_time`, `del_flag`, `sort`) VALUES (3, '1149088078300839936', 'Mongodb', '#128a3e', NULL, 1, '2023-09-06 21:05:47', b'0', 0);
INSERT INTO `article_tag` (`id`, `tag_id`, `name`, `color`, `icon`, `type`, `update_time`, `del_flag`, `sort`) VALUES (4, '1149088231174832128', 'Spring Boot', '#6cb52d', NULL, 1, '2023-09-06 21:06:23', b'0', 0);
INSERT INTO `article_tag` (`id`, `tag_id`, `name`, `color`, `icon`, `type`, `update_time`, `del_flag`, `sort`) VALUES (5, '1149088367896559616', 'Spring Cloud', '#6cb52d', NULL, 1, '2023-09-06 21:06:56', b'0', 0);
INSERT INTO `article_tag` (`id`, `tag_id`, `name`, `color`, `icon`, `type`, `update_time`, `del_flag`, `sort`) VALUES (6, '1149088674147860480', 'Linux', '#020204', NULL, 1, '2023-09-06 21:08:09', b'0', 0);
INSERT INTO `article_tag` (`id`, `tag_id`, `name`, `color`, `icon`, `type`, `update_time`, `del_flag`, `sort`) VALUES (7, '1149088921255280640', 'Matomo', '#ed7833', NULL, 1, '2024-01-29 18:39:23', b'0', 0);
INSERT INTO `article_tag` (`id`, `tag_id`, `name`, `color`, `icon`, `type`, `update_time`, `del_flag`, `sort`) VALUES (8, '1149107844310761472', 'Sitemap', '#ccc', NULL, 1, '2024-05-06 17:48:23', b'0', 0);
INSERT INTO `article_tag` (`id`, `tag_id`, `name`, `color`, `icon`, `type`, `update_time`, `del_flag`, `sort`) VALUES (9, '1149351551043764224', 'React', '#0074a6', NULL, 1, '2024-01-29 18:37:07', b'0', 0);
INSERT INTO `article_tag` (`id`, `tag_id`, `name`, `color`, `icon`, `type`, `update_time`, `del_flag`, `sort`) VALUES (10, '1149351884809699328', 'ANT DESIGN PRO', '#1890ff', NULL, 1, '2023-09-07 14:34:03', b'0', 0);
INSERT INTO `article_tag` (`id`, `tag_id`, `name`, `color`, `icon`, `type`, `update_time`, `del_flag`, `sort`) VALUES (11, '1149356153508069376', '笔记', 'red', NULL, 1, '2023-09-07 14:51:01', b'0', 0);
INSERT INTO `article_tag` (`id`, `tag_id`, `name`, `color`, `icon`, `type`, `update_time`, `del_flag`, `sort`) VALUES (12, '1220082946153775104', 'Java', '#e16516', NULL, 1, '2024-03-20 22:09:01', b'0', 0);
INSERT INTO `article_tag` (`id`, `tag_id`, `name`, `color`, `icon`, `type`, `update_time`, `del_flag`, `sort`) VALUES (13, '1237055176767045632', 'Node', 'rgb(65 126 56)', NULL, 1, '2024-05-06 14:55:38', b'0', 0);
COMMIT;

-- ----------------------------
-- Records of article_tag_config
-- ----------------------------
BEGIN;
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (1, '1083462433600831488', '1149088674147860480', b'1');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (2, '1083462433600831488', '1149085902136541184', b'1');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (3, '1148225827448684544', '1149084409815760896', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (4, '1080974668384567296', '1149085902136541184', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (5, '1080974668384567296', '1149088078300839936', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (6, '1080974668384567296', '1149088674147860480', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (7, '1080269597699080192', '1149085902136541184', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (8, '1080269597699080192', '1149088674147860480', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (9, '1080274561267793920', '1149085902136541184', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (10, '1080960516626710528', '1149088921255280640', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (11, '1080960516626710528', '1149085902136541184', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (12, '1083462433600831488', '1149107844310761472', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (13, '1149356083521912832', '1149351884809699328', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (14, '1149356083521912832', '1149351551043764224', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (15, '1149356083521912832', '1149356153508069376', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (16, '1080974668384567296', '1149356153508069376', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (17, '1080269597699080192', '1149356153508069376', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (18, '1080274561267793920', '1149356153508069376', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (19, '1080960516626710528', '1149356153508069376', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (20, '1173651087715074048', '1149356153508069376', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (21, '1183803984528408576', '1149356153508069376', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (22, '1200952712498380800', '1149356153508069376', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (23, '1214599156782465024', '1149356153508069376', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (24, '1219975936586416128', '1149084409815760896', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (25, '1220083916224987136', '1149356153508069376', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (26, '1220083916224987136', '1220082946153775104', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (27, '1237054899401916416', '1149356153508069376', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (28, '1237054899401916416', '1237055176767045632', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (29, '1238558446937309184', '1149351551043764224', b'0');
INSERT INTO `article_tag_config` (`id`, `article_id`, `tag_id`, `del_flag`) VALUES (30, '1238558446937309184', '1149351884809699328', b'0');
COMMIT;

-- ----------------------------
-- Records of friendly_link
-- ----------------------------
BEGIN;
INSERT INTO `friendly_link` (`id`, `name`, `link_url`, `avatar`, `email`, `email_public`, `remarks`, `sort`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `style`, `description`) VALUES (4, 'ANTD PRO VUE', 'https://pro.antdv.com/', 'https://www.antdv.com/assets/logo.1ef800a8.svg', '1', 0, '开箱即用的中台前端/设计解决方案', 998, '2023-02-27 13:09:55', '2024-01-26 15:34:44', '2', '2', 2, b'1', NULL, NULL);
INSERT INTO `friendly_link` (`id`, `name`, `link_url`, `avatar`, `email`, `email_public`, `remarks`, `sort`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `style`, `description`) VALUES (7, 'JavaQuan', 'https://javaquan.cn/article/', 'https://javaquan.cn/img/logo.png', 'javaquan@qq.com', 0, '', 0, NULL, '2024-03-19 10:58:41', NULL, NULL, 0, b'0', '', '一只爱折腾的攻城狮');
INSERT INTO `friendly_link` (`id`, `name`, `link_url`, `avatar`, `email`, `email_public`, `remarks`, `sort`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `style`, `description`) VALUES (16, '美团技术团队', 'https://tech.meituan.com/', 'https://dlvr.cpen.top/gh/mycpen/image_bed/image/202305140124461.jpg', '****@meituan.com', 0, NULL, 0, '2024-01-27 18:20:12', '2024-03-10 16:18:05', NULL, NULL, 0, b'0', 'background-color: #ffd138; --randomColor: #ffd138; color: #060108;', '一行代码，亿万生活。');
INSERT INTO `friendly_link` (`id`, `name`, `link_url`, `avatar`, `email`, `email_public`, `remarks`, `sort`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `style`, `description`) VALUES (17, 'JavaQuan', 'https://javaquan.cn', 'https://javaquan.cn/img/logo.png', 'javaquan@qq.com', 0, NULL, 0, '2024-02-06 21:14:13', '2024-02-26 06:21:28', NULL, NULL, 2, b'1', NULL, '申请友链');
COMMIT;

-- ----------------------------
-- Records of tools
-- ----------------------------
BEGIN;
INSERT INTO `tools` (`id`, `avatar`, `cover`, `remarks`, `title`, `data_type`, `list_type`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `content`, `jump_url`, `jump_type`, `sort`) VALUES (1, '', 'https://file.javaquan.cn/public//front-logo.svg', NULL, '时间戳转换', 1, 1, NULL, '2023-09-26 15:21:28', NULL, NULL, 0, b'0', '在线时间戳转换', 'https://tool.lu/timestamp/', 2, 2);
INSERT INTO `tools` (`id`, `avatar`, `cover`, `remarks`, `title`, `data_type`, `list_type`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `content`, `jump_url`, `jump_type`, `sort`) VALUES (2, '', 'https://file.javaquan.cn/public//front-logo.svg', NULL, 'JSON格式化', 2, 1, NULL, '2023-09-26 15:21:28', NULL, NULL, 0, b'0', '在线JSON格式化，JSON格式校验', 'https://www.zjson.net/', 2, 1);
INSERT INTO `tools` (`id`, `avatar`, `cover`, `remarks`, `title`, `data_type`, `list_type`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `content`, `jump_url`, `jump_type`, `sort`) VALUES (3, '', 'https://file.javaquan.cn/public//front-logo.svg', NULL, '代码编辑器', 1, 1, NULL, '2024-08-20 23:51:14', NULL, NULL, 2, b'0', '在线代码编辑器', '/tools/codeEditor', 1, NULL);
INSERT INTO `tools` (`id`, `avatar`, `cover`, `remarks`, `title`, `data_type`, `list_type`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `content`, `jump_url`, `jump_type`, `sort`) VALUES (5, NULL, 'https://file.javaquan.cn/public//front-logo.svg', NULL, '在线文本比对工具', 2, 1, NULL, '2023-09-26 15:21:28', NULL, NULL, 0, b'0', '在线文本对比工具', 'https://c.runoob.com/front-end/8006/', 2, NULL);
INSERT INTO `tools` (`id`, `avatar`, `cover`, `remarks`, `title`, `data_type`, `list_type`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `content`, `jump_url`, `jump_type`, `sort`) VALUES (6, 'https://tool.oschina.net/img/favicon.ico', 'https://file.javaquan.cn/public//front-logo.svg', NULL, '在线正则表达式测试', 1, 1, NULL, '2023-09-26 15:21:28', NULL, NULL, 0, b'0', '在线正则表达式工具', 'https://tool.oschina.net/regex/', 2, 0);
INSERT INTO `tools` (`id`, `avatar`, `cover`, `remarks`, `title`, `data_type`, `list_type`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `content`, `jump_url`, `jump_type`, `sort`) VALUES (7, 'https://tool.ip138.com/favicon.ico', 'https://file.javaquan.cn/public//front-logo.svg', '', 'URL在线解码', 3, 1, NULL, '2023-09-26 15:21:28', NULL, NULL, 0, b'0', 'URL在线编码解码工具', 'https://tool.ip138.com/urlencode/', 2, 0);
INSERT INTO `tools` (`id`, `avatar`, `cover`, `remarks`, `title`, `data_type`, `list_type`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `content`, `jump_url`, `jump_type`, `sort`) VALUES (8, 'https://lbsyun.baidu.com/skins/MySkin/resources/img/icon/lbsyunlogo_icon.ico', 'https://file.javaquan.cn/public//front-logo.svg', NULL, '百度坐标拾取系统', 1, 1, NULL, '2023-09-26 15:21:28', NULL, NULL, 0, b'0', NULL, 'https://api.map.baidu.com/lbsapi/getpoint/index.html', 2, 0);
INSERT INTO `tools` (`id`, `avatar`, `cover`, `remarks`, `title`, `data_type`, `list_type`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `content`, `jump_url`, `jump_type`, `sort`) VALUES (9, NULL, 'https://file.javaquan.cn/public//front-logo.svg', NULL, 'AI 搜索引擎', 1, 1, '2023-12-11 11:16:58', '2024-04-01 15:00:13', NULL, NULL, 2, b'0', '最懂程序员的新一代 AI 搜索引擎', 'https://devv.ai', 2, 0);
INSERT INTO `tools` (`id`, `avatar`, `cover`, `remarks`, `title`, `data_type`, `list_type`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `content`, `jump_url`, `jump_type`, `sort`) VALUES (10, NULL, 'https://file.javaquan.cn/public//front-logo.svg', NULL, '阿里云官方镜像站', 4, 1, '2024-03-13 23:15:33', '2024-04-01 15:02:20', NULL, NULL, 0, b'0', '提供极速全面稳定的系统镜像服务', 'https://developer.aliyun.com/mirror/?spm=a2c6h.13651102.0.0.6a091b11PFjz8y&serviceType=mirror', 2, 0);
INSERT INTO `tools` (`id`, `avatar`, `cover`, `remarks`, `title`, `data_type`, `list_type`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `content`, `jump_url`, `jump_type`, `sort`) VALUES (11, NULL, 'https://file.javaquan.cn/public//front-logo.svg', NULL, '地图坐标系转换', 1, 1, '2024-05-30 15:29:31', '2024-05-30 15:39:30', NULL, NULL, 0, b'0', NULL, 'https://tool.lu/coordinate', 2, 0);
INSERT INTO `tools` (`id`, `avatar`, `cover`, `remarks`, `title`, `data_type`, `list_type`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `content`, `jump_url`, `jump_type`, `sort`) VALUES (12, 'https://eclipse.dev/eclipse.org-common/themes/solstice/public/images/favicon.ico', 'https://eclipse.dev/mat/home/mat_thumb.png', NULL, 'Memory Analyzer (MAT)', 4, 1, '2024-05-31 10:06:46', '2024-05-31 10:06:46', NULL, NULL, 0, b'0', 'Eclipse内存分析器是一个快速且功能丰富的Java堆分析器，可帮助您找到内存泄漏并减少内存消耗。', 'https://eclipse.dev/mat/', 2, 0);
INSERT INTO `tools` (`id`, `avatar`, `cover`, `remarks`, `title`, `data_type`, `list_type`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `content`, `jump_url`, `jump_type`, `sort`) VALUES (14, NULL, 'https://img.alicdn.com/tfs/TB12PGuocKfxu4jSZPfXXb3dXXa-149-18.svg', NULL, '阿里云Maven私有仓库', 4, 1, '2024-10-22 11:52:41', '2024-10-22 11:52:41', NULL, NULL, 0, b'0', NULL, 'https://developer.aliyun.com/mvn/search', 2, 0);
INSERT INTO `tools` (`id`, `avatar`, `cover`, `remarks`, `title`, `data_type`, `list_type`, `create_time`, `update_time`, `create_user`, `update_user`, `status`, `del_flag`, `content`, `jump_url`, `jump_type`, `sort`) VALUES (15, NULL, NULL, NULL, 'JDK各版本下载链接', 4, 1, '2024-10-25 17:54:17', '2024-10-25 17:54:17', NULL, NULL, 1, b'0', NULL, 'https://www.oracle.com/java/technologies/downloads/archive/', 2, 0);
COMMIT;